﻿CREATE PROCEDURE [dbo].[proc_Loan_GetItem]
	(
		
		@id int
	)
AS
begin
	
	
	
	 SELECT 
	
	  id,[CompanyId]
      ,[CompanyName]
      ,[DepartmentId]
      ,[DepartmentName]
      ,[ENameId]
      ,[EName]
      ,[PostCategoryId]
      ,[PostCategory]
      ,[Address]
      ,[Days]
      ,[Money]
      ,[Cause]
      ,[PZPerson]
      ,[PZPersonName]
      ,[SHPerson]
      ,[SHPersonName]
      ,[lrrq]
      ,[userid]
      ,[username]
      ,[Summary],PaymentTypeName, BankName,typeid FROM Loan WHERE id=@id
      
    
	

	
	
end			
	RETURN
